ORSANCO Diagrams

1. Migrate .mdb and .accdb to MS SQL Server (Express) using Microsoft SQL Server Migration Assistant for Access.
2. Connect a Django project to the new MS SQL Server database(s).
3. Generate models from this MS SQL Server connection (database-first approach).
4. Add new Django DB connection(s) to PSQL database(s).
5. Run migrations to generate new tables in PSQL.
6. Use Django ORM to migrate all data from MS SQL Server to PSQL.
7. Manually modify generated models to adhere to Python/PSQL standards.

Database Dependencies

We do not have access to the blue databases.

Green are Excel Workbooks or Sheets.

Blue are Tables

Not colored are Queries

Final Report Diagrams